代写完成–Java GUI + JDBC 连接 Mysql: 咖啡馆人员管理系统
Your dance instructor has asked you to design a quick and easy program to keep track of the some pertinent data for the dancers at Café Dansa Club, an establishment offering classes in various styles of dancing. Currently no such program exists and it is difficult to update the information of the dancers.
Write a Java program that allows the user to manage a simple dancers’ database with ability to display, add, edit/modify, and delete the dancers who frequent the Café Dansa Club. Sample GUI is provided as one example of an implementation. There is a lot of flexibility however for your vision of how to design and implement this database, as long as your implementation has all of the required functionality.
Your program must contain/do:
A Dancer class that contains in order at least name, dance preference style, proficiency, length of dancing, phone, and email. The class should also include a default and an overloaded constructor, accessors and mutators, toString() method, and equals() method.
Read and display the information about the dancer in a GUI-based driver. You cannot decide for yourself the back end: it must be relational DB such as SQL. An example of data with comma delimited text file that you must convert to a table to be mined with SQL statements might be:
1
2
3
4
5
6
7
8
9
10
11
12
13
14Anna,Pavlova,ballet,expert,32,425-125-9874,ana.pavlova@dance.com
Vaslav,Nijinsky,ballet,master,40,206-675-1280,nijinsky@ballet.net
Fred,Astaire,ballroom,master,360,310-387-4499,astaire@ballet.net
Sammy,Davis,tap,expert,27,909-123-6578,davis@pop.com
Gene,Kelly,ballroom,beginner,12,707-945-7765,kelly@ballroom.com
Mikhail,Baryshnikov,ballet,intermediate,,baryshnikov@ballet.com
Michael,Jackson,modern pop,advanced,9,303-313-5455,michael@pop.com
Luara,como Lino,samba,advanced,18,452-257-6733,nijinsky@ballet.com
Magan,Gopal,salsa,intemediate,6,206-675-1280,gopal@salsa.com
Sukshinder Shinda,bhangra,beginner,2,661-038-9512,sshinda@bhangra.com
Michael,Ryan Flatley,irish,intemediate,30,254-113-6457,flastley@irish.com
Rags,Sharqi,baladi,advanced,14,684-031-3210,rags.sharqi@baladi.com
Cherie,Magnus,milonga,beginner,5,206-675-1280,magus@milonga.com
Kahte,Culevski,balkan,advanced,8,321-741-3771,kculevski@balkanbeat.netAbility to add new dancers, modify existing ones, and delete dancers from the database.
Checks should be performed not to add duplicate entries of the same dancer, and that all of the required fields are valid and included when adding/editing a dancer.A data structure of dancers to hold the members data. This should be an ArrayList.
Javadocs, description of the program, and comments.
Menus that synchronize with corresponding buttons and with at least the following menu choices:
- File with Clear, Print, and Exit menu items.
- Sort with Sort by First Name, Last Name and by Years of experience menu items.
- Action with Add, Delete, Edit (with choice to save or cancel changes) menu items, and Search by multiple fields: name, level, style, and years.
- Help with an About menu item for a meaningful About form.
The lab should start with an exciting Splash Screen (as a separate Thread) with progress bar that closes itself after so many seconds.
Well designed and efficient GUI with images and ease to use.
Print the information for a specified dancer (with the Print JButton) and print the entire form (from the File -> Print selection).
Sepate forms (classes) for Adding and Editing a dancer that use a Validation class with regular expression for validating input into the forms.
Enable and disable JButtons and menu choices appropriately (so, for example, if the Edit JButton is pressed the others, including the corresponding menu choices and the JList, should be disabled until the editing is done).
You DB should contain at least three properly interconnected tables: Dancers, DanceStyles, and DanceLevels.
Optionally, consider adding images for each dancer and multimedia (video/audio of a sample dance style for each dance style).
Screen Captures:
